From 73a87bd05151e326569a060d8baf4011803c9852 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 21 Oct 2025 22:24:48 +0000 Subject: [PATCH] Adjust conversion for BIOGRAPHY_DATA.DadPrelim -> DadStatus change Solves conversion problem #11. --- conversion/load_biography.sql | 8 +++++--- conversion/load_support.sql | 7 +++++++ 2 files changed, 12 insertions(+), 3 deletions(-) diff --git a/conversion/load_biography.sql b/conversion/load_biography.sql index bda92a2..a0b522c 100644 --- a/conversion/load_biography.sql +++ b/conversion/load_biography.sql @@ -32,7 +32,7 @@ INSERT INTO biography_data( ,sex ,momid ,dadid - ,dadprelim + ,dadstatus ,dadidpub ,firstborn ,birthdate @@ -60,9 +60,11 @@ INSERT INTO biography_data( , CASE WHEN (b_dadid IS NULL OR b_dadid = '') THEN NULL + WHEN b_animid = 'KAZ' -- Problem #11 + THEN 'Quest' WHEN split_part(b_dadid, '_', 2) = 'prelim' - THEN TRUE - ELSE FALSE + THEN 'Prelim' + ELSE 'Norm' END CASE , CASE WHEN b_dadid_publication_info = '' AND (b_dadid IS NOT NULL diff --git a/conversion/load_support.sql b/conversion/load_support.sql index 541c3af..e440461 100644 --- a/conversion/load_support.sql +++ b/conversion/load_support.sql @@ -88,6 +88,13 @@ INSERT INTO cycle_states (code, description) , ('n/a', 'Male') , ('MISS', 'Missing data'); -- problem #42 +-- dad_statuses +INSERT INTO dad_statuses (status, description) + VALUES ('Prelim', 'Preliminary paternity assignment') + , ('Norm', 'A normal paternity assignment') + , ('Quest', 'Paternity is assigned, but there is more than' + || ' one possibility'); + -- departtypes INSERT INTO departtypes (departtype, description) VALUES ('D', 'Death') -- 2.34.1